
package com.jsu.collegestudentadmissionsystem.dao;

import com.jsu.collegestudentadmissionsystem.pojo.vo.*;
import org.apache.ibatis.annotations.Mapper;
import org.springframework.stereotype.Repository;

import java.util.List;

@Mapper
@Repository
public interface AdministratorDao {

    Integer querStatus();

    void setStatus(Integer sta);

    void insertMajorInformation(Integer s, String s1, String s2);

    void deleteMajorInformation(Integer s);

    void alterMajorInformation(Integer s, String s1, String s2);

    List<MajorInformation> queryMajorInformation();



    void insertMiddleSchoolInformation(Integer middle_school_id, String middle_school_name);

    void deleteMiddleSchoolInformation(Integer middle_school_id);

    void alterMiddleSchoolInformation(Integer id, Integer middle_school_id, String middle_school_name);

    List<MiddleSchoolInformation> queryMiddleSchoolInformation();



    void insertCollegeMajorInformation(Integer college_major_id, Integer college_id, Integer major_id, Integer admission_batch_id, Integer admission_quantity);

    void deleteCollegeMajorInformation(Integer college_major_id);

    void alterCollegeMajorInformation(Integer college_major_id, Integer college_id, Integer major_id, Integer admission_batch_id, Integer admission_quantity);

    List<CollegeMajorInformation> queryCollegeMajorInformation();



    void insertScoreInformation( Integer student_id, float main_subject_score_one, float main_subject_score_two, float main_subject_score_three, float subject_score_one, float subject_score_two, float subject_score_three, int total_score);

    void deleteScoreInformation(Integer middle_school_id);

    void alterScoreInformation(Integer score_id, Integer student_id, float main_subject_score_one, float main_subject_score_two, float main_subject_score_three, float subject_score_one, float subject_score_two, float subject_score_three, float total_score);

    List<ScoreInformation> queryScoreInformation();



    void insertStudentInformation(Integer studentId, String studentName, Integer middleSchoolId, Integer classId);

    void insertCollegeInformation( String collegeCode,String collegeName , String collegeAddress);

    /**
     * 像这种查询的sql 都要写返回类型 如果是返回一条数据 就直接StudentInformation
     * 如果是多条数据 就用List<>把他包起来
     * @return
     */
    List<StudentInformation> searchStudentInformation();

    List<CollegeInformation> searchCollegeInformation();

    MiddleSchoolInformation queryMiddleSchoolByName(String middleSchoolName);
}

